Release 10.1A: OpenEdge Data Management:
SQL Reference

TO_TIMESTAMP

Converts the given timestamp literal to a timestamp value.

Syntax

TO_TIMESTAMP ( timestamp_lit )

Example

The following example shows how to use the TO_TIMESTAMP function:

SELECT * FROM DTEST WHERE C3 = TO_TIMESTAMP('4/18/03 10:41:19')

Notes

The result is of type TIME.
Supply the timestamp literal in any valid format.

Compatibility

Progress Extension